Managing Database Using Shell / SSH

Secure Shell, sometimes referred to as Secure Socket Shell, is a protocol which allows you to connect securely to a remote computer or a server by using a text-based interface.

When a secure SSH connection is established, a shell session will be started, and you will be able to make application-related changes in a container by issuing commands. This article wills show how you can do it.

Note: For the security purpose, only the account holders who pass our verification will be granted permission to the Shell / SSH service. If you would like to enable it, please update your billing information. Our staff will finish verifying your information within 2 hours.

1. Locate your target deployment

Log in to the Control Panel and locate your target deployment on the Home page or the My Applications page.

2．Get connection string information

Click the "Manage" button on the Home page or the My Applications page to go to the Overview page.

copy the connection string for your database in the Connection Information section.

3. Go to the Shell / SSH page

Click the “Shell / SSH” tab > the connect icon to open the shell interface.

4. Connect to the database

Please copy the Shell connection string to the command window. Replace the<User>and<Password> with your own database user and password in order to connect to the Oracle server.

5. Manage your database

Now you are ready to manage your database using command lines as you like.